ALTER TABLE `groups` CHANGE `groupId` `groupId` INT(11) NOT NULL;
ALTER TABLE `groups` DROP PRIMARY KEY;
